Turbocharging database query processing and testing
نویسندگان
چکیده
منابع مشابه
Advance Database Aggregation Query Processing
The aggregation query is an important but costly operation in database management systems. In the worst case, to compute an aggregate, all tuples in a database needs to be examined. However, in many applications (on-line analysis, etc.), we need to compute the aggregates very fast. In the Ph.D. research, we focus on devising specialized indices for the box-aggregation query and its relatives. O...
متن کاملTesting relational database query optimization strategies
Query optimization is one of the most important problems in databases. Query optimization can be talked about in different scenarios with different tools and different results. In this paper we’ll talk about query processing and optimization and test strategies in different context, starting from simple queries continuing with correlated queries, joins with or without different indexing strateg...
متن کاملQuery Processing Techniques in the Team-Oriented Database Query Language
In this paper, we introduce the concept “team” and incorporate the team query into data language SQL. Existing relational query languages use tuple variables of tables to specify required data. Queries that are expressed by these languages are used to get all the data which satisfy the specified conditions. While a team variable represents a subset of a table, a team query is to retrieve all th...
متن کاملSpatial Query Processing in Geographic Database Systems
In this pupcar, we propose U spaliul qwrv languagt., called GSQL, to hurdle complex spatial olvects such us points, lines, rectangles, or polygons. To implemcvtt the ypatiul operutors such JS nearest, furthest, intersect, CO ver, adjacent-to, end-at, and distance. we present U two-phase query processing technique ionwt ing of a filter phase urd a refinement phase. The filter phase i s h u e d o...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Communications of the ACM
سال: 2019
ISSN: 0001-0782,1557-7317
DOI: 10.1145/3347861